Spread Windows Forms 9.0 Product Documentation
ConditionalFormatting Constructor(IEnumerable<CellRange>)
Example 


The ranges.
Initializes a new instance of the ConditionalFormatting class.
Syntax
'Declaration
 
Public Function New( _
   ByVal ranges As IEnumerable(Of CellRange) _
)
'Usage
 
Dim ranges As IEnumerable(Of CellRange)
 
Dim instance As New ConditionalFormatting(ranges)
public ConditionalFormatting( 
   IEnumerable<CellRange> ranges
)

Parameters

ranges
The ranges.
Example
This example creates a conditional rule.
private void Form1_Load(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
            fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
            fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
            fpSpread1.Sheets[0].Cells[0, 2].Value = 1;            
        }

        private void button1_Click(object sender, EventArgs e)
        {
            FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo,  10, false);
            unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo;
            unary.Value = 10;
            unary.BackColor = Color.Red;
            unary.FontStyle = new FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold);
            
            FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule topRank = new FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule();
            topRank.IsDescending = true;
            topRank.BackColor = Color.Tomato;
            topRank.ForeColor = Color.Yellow;

            //CondtionalFormatting Constructor
            FarPoint.Win.Spread.ConditionalFormatting cf2 = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange[] { new FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 1), new FarPoint.Win.Spread.Model.CellRange(1, 1, 2, 2) });
            FarPoint.Win.Spread.ConditionalFormatting cf3 = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange[] { new FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 1), new FarPoint.Win.Spread.Model.CellRange(1, 1, 2, 2) }, topRank);
            fpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf2);
            fpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf3);
    }
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.Sheets(0).Cells(0, 0).Value = 3
        FpSpread1.Sheets(0).Cells(1, 0).Value = 2
        FpSpread1.Sheets(0).Cells(1, 1).Value = 10
        FpSpread1.Sheets(0).Cells(0, 2).Value = 1
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim unary As New FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 10, False)
        unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo
        unary.Value = 10
        unary.BackColor = Color.Red
        unary.FontStyle = New FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold)

        Dim topRank As New FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule()
        topRank.IsDescending = True
        topRank.BackColor = Color.Tomato
        topRank.ForeColor = Color.Yellow

        'CondtionalFormatting Constructor
        Dim cf2 As New FarPoint.Win.Spread.ConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange() {New FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 1), New FarPoint.Win.Spread.Model.CellRange(1, 1, 2, 2)})
        Dim cf3 As New FarPoint.Win.Spread.ConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange() {New FarPoint.Win.Spread.Model.CellRange(0, 0, 1, 1), New FarPoint.Win.Spread.Model.CellRange(1, 1, 2, 2)}, topRank)
        FpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf2)
        FpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf3)
    End Sub
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

ConditionalFormatting Class
ConditionalFormatting Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.